﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="i2iPortal" targetNamespace="http://tempuri.org/i2iPortal.xsd" xmlns:mstns="http://tempuri.org/i2iPortal.xsd" xmlns="http://tempuri.org/i2iPortal.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DataSetFile="i2iPortal.Dataset.Designer.cs" DataSetProject="Data" DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DataAccess.Properties.Settings.GlobalReference.Default.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Users] WHERE (([user_id] = @Original_user_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Users] ([username], [password], [is_admin], [role], [client_id], [name], [email]) VALUES (@username, @password, @is_admin, @role, @client_id, @name, @email)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@is_admin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="is_admin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Users.*
FROM  Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Users] SET [username] = @username, [password] = @password, [is_admin] = @is_admin, [role] = @role, [client_id] = @client_id, [name] = @name, [email] = @email WHERE (([user_id] = @Original_user_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@is_admin" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="is_admin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@role" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="role" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="user_id" DataSetColumn="user_id" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="is_admin" DataSetColumn="is_admin" />
              <Mapping SourceColumn="role" DataSetColumn="role" />
              <Mapping SourceColumn="client_id" DataSetColumn="client_id" />
              <Mapping SourceColumn="name" DataSetColumn="name" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByClientID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByClientID" GeneratorSourceName="FillByClientID" GetMethodModifier="Public" GetMethodName="GetDataByClientID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByClientID" UserSourceName="FillByClientID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT client_id, email, is_admin, name, password, role, user_id, username FROM Users WHERE (client_id = @client_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="client_id" ColumnName="client_id" DataSourceName="[345671_i2iportal_db].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByUserID" GeneratorSourceName="FillByUserID" GetMethodModifier="Public" GetMethodName="GetDataByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByUserID" UserSourceName="FillByUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT client_id, email, is_admin, name, password, role, user_id, username FROM Users WHERE (user_id = @user_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="user_id" ColumnName="user_id" DataSourceName="[345671_i2iportal_db].dbo.Users" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ComponentsTableAdapter" GeneratorDataComponentClassName="ComponentsTableAdapter" Name="Components" UserDataComponentName="ComponentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Components" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByInterVal" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetTestInterVal" GeneratorSourceName="FillByInterVal" GetMethodModifier="Public" GetMethodName="GetTestInterVal" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetTestInterVal" UserSourceName="FillByInterVal">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Components] WHERE (([component_id] = @Original_component_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Components] ([machine_id], [componentName], [category_id], [Interval_Id]) VALUES (@machine_id, @componentName, @category_id, @Interval_Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@componentName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="componentName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Interval_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Interval_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  component_id, machine_id, componentName, category_id, Interval_Id,
                       (SELECT  Name
                        FROM       TestInterVal AS t
                        WHERE    (Interval_Id = c.Interval_Id)) AS InterValName
FROM      Components AS c WHERE (component_id=@component_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Components] SET [machine_id] = @machine_id, [componentName] = @componentName, [category_id] = @category_id, [Interval_Id] = @Interval_Id WHERE (([component_id] = @Original_component_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@componentName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="componentName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@category_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="category_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Interval_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Interval_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="component_id" DataSetColumn="component_id" />
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="componentName" DataSetColumn="componentName" />
              <Mapping SourceColumn="category_id" DataSetColumn="category_id" />
              <Mapping SourceColumn="Interval_Id" DataSetColumn="Interval_Id" />
              <Mapping SourceColumn="InterValName" DataSetColumn="InterValName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Components" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByComponentID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByComponentID" GeneratorSourceName="FillByComponentID" GetMethodModifier="Public" GetMethodName="GetDataByComponentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByComponentID" UserSourceName="FillByComponentID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Interval_Id, category_id, componentName, component_id, machine_id FROM Components WHERE (component_id = @component_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Components" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByMachineID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMachineID" GeneratorSourceName="FillByMachineID" GetMethodModifier="Public" GetMethodName="GetDataByMachineID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMachineID" UserSourceName="FillByMachineID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Interval_Id, category_id, componentName, component_id, machine_id FROM Components WHERE (machine_id = @machine_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="machine_id" ColumnName="machine_id" DataSourceName="[345671_i2iportal_db].dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Components" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillCpByInterval" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetCpByInterval" GeneratorSourceName="FillCpByInterval" GetMethodModifier="Public" GetMethodName="GetCpByInterval" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetCpByInterval" UserSourceName="FillCpByInterval">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  component_id, machine_id,(select machineName From Machines m where m.machine_id = c.machine_id) as machineName, componentName, category_id, Interval_Id
FROM      Components AS c WHERE (Interval_Id = @Interval_Id) Order by machine_id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Interval_Id" ColumnName="Interval_Id" DataSourceName="[345671_i2iportal_db].dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Interval_Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Interval_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkOrdersTableAdapter" GeneratorDataComponentClassName="WorkOrdersTableAdapter" Name="WorkOrders" UserDataComponentName="WorkOrdersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.WorkOrders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [WorkOrders] WHERE (([workorder_id] = @Original_workorder_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [WorkOrders] ([workorder_reference_no], [machine_id], [description], [action], [date_submitted]) VALUES (@workorder_reference_no, @machine_id, @description, @action, @date_submitted)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date_submitted" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT WorkOrders.*
FROM     WorkOrders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [WorkOrders] SET [workorder_reference_no] = @workorder_reference_no, [machine_id] = @machine_id, [description] = @description, [action] = @action, [date_submitted] = @date_submitted WHERE (([workorder_id] = @Original_workorder_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@date_submitted" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="workorder_id" DataSetColumn="workorder_id" />
              <Mapping SourceColumn="workorder_reference_no" DataSetColumn="workorder_reference_no" />
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="action" DataSetColumn="action" />
              <Mapping SourceColumn="date_submitted" DataSetColumn="date_submitted" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.WorkOrders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByMachineID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMachineID" GeneratorSourceName="FillByMachineID" GetMethodModifier="Public" GetMethodName="GetDataByMachineID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMachineID" UserSourceName="FillByMachineID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT WorkOrders.*
FROM  WorkOrders
WHERE (machine_id = @machine_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="machine_id" ColumnName="machine_id" DataSourceName="[345671_i2iportal_db].dbo.WorkOrders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.WorkOrders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByWorkOrderID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByWorkOrderID" GeneratorSourceName="FillByWorkOrderID" GetMethodModifier="Public" GetMethodName="GetDataByWorkOrderID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByWorkOrderID" UserSourceName="FillByWorkOrderID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT WorkOrders.*
FROM  WorkOrders
WHERE (workorder_id = @workorder_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="workorder_id" ColumnName="workorder_id" DataSourceName="[345671_i2iportal_db].dbo.WorkOrders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StatusTableAdapter" GeneratorDataComponentClassName="StatusTableAdapter" Name="Status" UserDataComponentName="StatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Status" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Status] WHERE (([status_id] = @Original_status_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Status] ([statusName], [statusDescription]) VALUES (@statusName, @statusDescription)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Status.*
FROM     Status</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Status] SET [statusName] = @statusName, [statusDescription] = @statusDescription WHERE (([status_id] = @Original_status_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="status_id" DataSetColumn="status_id" />
              <Mapping SourceColumn="statusName" DataSetColumn="statusName" />
              <Mapping SourceColumn="statusDescription" DataSetColumn="statusDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ComponentStatusTableAdapter" GeneratorDataComponentClassName="ComponentStatusTableAdapter" Name="ComponentStatus" UserDataComponentName="ComponentStatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.ComponentStatus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [ComponentStatus] WHERE (([component_id] = @Original_component_id) AND ([dateRecorded] = @Original_dateRecorded))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dateRecorded" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dateRecorded" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [ComponentStatus] ([component_id], [status_id], [comments], [dateRecorded], [dateEntered], [comment_id]) VALUES (@component_id, @status_id, @comments, @dateRecorded, @dateEntered, @comment_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@comments" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dateRecorded" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dateRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dateEntered" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dateEntered" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@comment_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comment_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ComponentStatus.*
FROM     ComponentStatus</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [ComponentStatus] SET [component_id] = @component_id, [status_id] = @status_id, [comments] = @comments, [dateRecorded] = @dateRecorded, [dateEntered] = @dateEntered, [comment_id] = @comment_id WHERE (([component_id] = @Original_component_id) AND ([dateRecorded] = @Original_dateRecorded))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@comments" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="comments" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dateRecorded" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dateRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@dateEntered" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dateEntered" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@comment_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comment_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_dateRecorded" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="dateRecorded" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="component_id" DataSetColumn="component_id" />
              <Mapping SourceColumn="status_id" DataSetColumn="status_id" />
              <Mapping SourceColumn="comments" DataSetColumn="comments" />
              <Mapping SourceColumn="dateRecorded" DataSetColumn="dateRecorded" />
              <Mapping SourceColumn="dateEntered" DataSetColumn="dateEntered" />
              <Mapping SourceColumn="comment_id" DataSetColumn="comment_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.ComponentStatus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByComponentID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByComponentID" GeneratorSourceName="FillByComponentID" GetMethodModifier="Public" GetMethodName="GetDataByComponentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByComponentID" UserSourceName="FillByComponentID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT comment_id, comments, component_id, dateEntered, dateRecorded, status_id FROM ComponentStatus WHERE (component_id = @component_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.ComponentStatus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.ComponentStatus" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByComponentIDandDateRecorded" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByComponentIDandDateRecorded" GeneratorSourceName="FillByComponentIDandDateRecorded" GetMethodModifier="Public" GetMethodName="GetDataByComponentIDandDateRecorded" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByComponentIDandDateRecorded" UserSourceName="FillByComponentIDandDateRecorded">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT comment_id, comments, component_id, dateEntered, dateRecorded, status_id FROM ComponentStatus WHERE (component_id = @component_id) AND (dateRecorded = @dateRecorded)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.ComponentStatus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="dateRecorded" ColumnName="dateRecorded" DataSourceName="[345671_i2iportal_db].dbo.ComponentStatus" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@dateRecorded" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="dateRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StandardCommentsTableAdapter" GeneratorDataComponentClassName="StandardCommentsTableAdapter" Name="StandardComments" UserDataComponentName="StandardCommentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.StandardComments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [StandardComments] WHERE (([comment_id] = @Original_comment_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_comment_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comment_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [StandardComments] ([commentDescription], [status_id]) VALUES (@commentDescription, @status_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@commentDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="commentDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT StandardComments.*
FROM     StandardComments</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [StandardComments] SET [commentDescription] = @commentDescription, [status_id] = @status_id WHERE (([comment_id] = @Original_comment_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@commentDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="commentDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_comment_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="comment_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="comment_id" DataSetColumn="comment_id" />
              <Mapping SourceColumn="commentDescription" DataSetColumn="commentDescription" />
              <Mapping SourceColumn="status_id" DataSetColumn="status_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.StandardComments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCommentID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCommentID" GeneratorSourceName="FillByCommentID" GetMethodModifier="Public" GetMethodName="GetDataByCommentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCommentID" UserSourceName="FillByCommentID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT commentDescription, comment_id, status_id FROM StandardComments WHERE (comment_id = @comment_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="comment_id" ColumnName="comment_id" DataSourceName="[345671_i2iportal_db].dbo.StandardComments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@comment_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="comment_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.StandardComments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByStatusID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByStatusID" GeneratorSourceName="FillByStatusID" GetMethodModifier="Public" GetMethodName="GetDataByStatusID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByStatusID" UserSourceName="FillByStatusID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT commentDescription, comment_id, status_id FROM StandardComments WHERE (status_id = @status_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="status_id" ColumnName="status_id" DataSourceName="[345671_i2iportal_db].dbo.StandardComments" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@status_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="status_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientForComponentTableAdapter" GeneratorDataComponentClassName="ClientForComponentTableAdapter" Name="ComponentForClient" UserDataComponentName="ClientForComponentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Clients" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetClientIDByComponentID" GetMethodModifier="Public" GetMethodName="GetClientIDByComponentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetClientIDByComponentID" UserSourceName="GetClientIDByComponentID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  ct.client_id
FROM      Clients AS ct INNER JOIN
                   Sites AS st ON ct.client_id = st.client_id INNER JOIN
                   Machines AS mh ON st.site_id = mh.site_id INNER JOIN
                   Components AS cp ON mh.machine_id = cp.machine_id
WHERE   (cp.component_id = @componentID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="componentID" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@componentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="client_id" DataSetColumn="client_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Machines.machine_id, Machines.site_id, Machines.machineName, Machines.status, Machines.photo, Sites.siteName, Clients.clientName
FROM  Sites INNER JOIN
               Machines ON Sites.site_id = Machines.site_id INNER JOIN
               Clients ON Sites.client_id = Clients.client_id </CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SitesOnClientsTableAdapter" GeneratorDataComponentClassName="SitesOnClientsTableAdapter" Name="SitesOnClients" UserDataComponentName="SitesOnClientsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Sites.*, Clients.clientName
FROM  Clients INNER JOIN
               Sites ON Clients.client_id = Sites.client_id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="site_id" DataSetColumn="site_id" />
              <Mapping SourceColumn="siteName" DataSetColumn="siteName" />
              <Mapping SourceColumn="client_id" DataSetColumn="client_id" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="clientName" DataSetColumn="clientName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Sites.*, Clients.clientName
FROM  Clients INNER JOIN
               Sites ON Clients.client_id = Sites.client_id where (Clients.client_id = @client_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="client_id" ColumnName="client_id" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ComponentsOnMachinesTableAdapter" GeneratorDataComponentClassName="ComponentsOnMachinesTableAdapter" Name="ComponentsOnMachines" UserDataComponentName="ComponentsOnMachinesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Components.*, Machines.machineName, Sites.siteName
FROM  Machines INNER JOIN
               Components ON Machines.machine_id = Components.machine_id INNER JOIN
               Sites ON Machines.site_id = Sites.site_id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="component_id" DataSetColumn="component_id" />
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="componentName" DataSetColumn="componentName" />
              <Mapping SourceColumn="machineName" DataSetColumn="machineName" />
              <Mapping SourceColumn="siteName" DataSetColumn="siteName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetComponentDetailByID" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetComponentDetailByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetComponentDetailByID" UserSourceName="GetComponentDetailByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Components.component_id, Components.machine_id, Components.componentName, Components.category_id, Components.Interval_Id, Machines.machineName, 
                         Sites.siteName
FROM            Machines INNER JOIN
                         Components ON Machines.machine_id = Components.machine_id INNER JOIN
                         Sites ON Machines.site_id = Sites.site_id AND Components.component_id = @component_id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.Components" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ComponentStatusOnComponentsTableAdapter" GeneratorDataComponentClassName="ComponentStatusOnComponentsTableAdapter" Name="ComponentStatusOnComponents" UserDataComponentName="ComponentStatusOnComponentsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ComponentStatus.*, Components.componentName, Status.statusName, StandardComments.commentDescription
FROM  ComponentStatus INNER JOIN
               Components ON ComponentStatus.component_id = Components.component_id INNER JOIN
               Status ON ComponentStatus.status_id = Status.status_id INNER JOIN
               StandardComments ON ComponentStatus.comment_id = StandardComments.comment_id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="component_id" DataSetColumn="component_id" />
              <Mapping SourceColumn="status_id" DataSetColumn="status_id" />
              <Mapping SourceColumn="comments" DataSetColumn="comments" />
              <Mapping SourceColumn="dateRecorded" DataSetColumn="dateRecorded" />
              <Mapping SourceColumn="dateEntered" DataSetColumn="dateEntered" />
              <Mapping SourceColumn="comment_id" DataSetColumn="comment_id" />
              <Mapping SourceColumn="componentName" DataSetColumn="componentName" />
              <Mapping SourceColumn="statusName" DataSetColumn="statusName" />
              <Mapping SourceColumn="commentDescription" DataSetColumn="commentDescription" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM ComponentStatus</CommandText>
                    <Parameters />
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByComponentID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByComponentID" GeneratorSourceName="FillByComponentID" GetMethodModifier="Public" GetMethodName="GetDataByComponentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByComponentID" UserSourceName="FillByComponentID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ComponentStatus.*, Components.componentName, Status.statusName, StandardComments.commentDescription
FROM  ComponentStatus INNER JOIN
               Components ON ComponentStatus.component_id = Components.component_id INNER JOIN
               Status ON ComponentStatus.status_id = Status.status_id INNER JOIN
               StandardComments ON ComponentStatus.comment_id = StandardComments.comment_id
WHERE ComponentStatus.component_id = @component_id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.ComponentStatus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByComponentIDandDateRecorded" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByComponentIDandDateRecorded" GeneratorSourceName="FillByComponentIDandDateRecorded" GetMethodModifier="Public" GetMethodName="GetDataByComponentIDandDateRecorded" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByComponentIDandDateRecorded" UserSourceName="FillByComponentIDandDateRecorded">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ComponentStatus.*, Components.componentName, Status.statusName, StandardComments.commentDescription
FROM  ComponentStatus INNER JOIN
               Components ON ComponentStatus.component_id = Components.component_id INNER JOIN
               Status ON ComponentStatus.status_id = Status.status_id INNER JOIN
               StandardComments ON ComponentStatus.comment_id = StandardComments.comment_id
WHERE ComponentStatus.component_id = @component_id 
AND dateRecorded =@dateRecorded</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="component_id" DataSourceName="[345671_i2iportal_db].dbo.ComponentStatus" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="dateRecorded" ColumnName="dateRecorded" DataSourceName="[345671_i2iportal_db].dbo.ComponentStatus" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@dateRecorded" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="dateRecorded" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkOrdersOnMachinesTableAdapter" GeneratorDataComponentClassName="WorkOrdersOnMachinesTableAdapter" Name="WorkOrdersOnMachines" UserDataComponentName="WorkOrdersOnMachinesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT WorkOrders.*, Machines.machineName
FROM  WorkOrders INNER JOIN
               Machines ON WorkOrders.machine_id = Machines.machine_id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="workorder_id" DataSetColumn="workorder_id" />
              <Mapping SourceColumn="workorder_reference_no" DataSetColumn="workorder_reference_no" />
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="action" DataSetColumn="action" />
              <Mapping SourceColumn="date_submitted" DataSetColumn="date_submitted" />
              <Mapping SourceColumn="machineName" DataSetColumn="machineName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SitesTableAdapter" GeneratorDataComponentClassName="SitesTableAdapter" Name="Sites" UserDataComponentName="SitesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Sites" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Sites] WHERE (([site_id] = @Original_site_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_site_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="site_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Sites] ([siteName], [client_id], [status]) VALUES (@siteName, @client_id, @status)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@siteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="siteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Sites.*
FROM     Sites</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Sites] SET [siteName] = @siteName, [client_id] = @client_id, [status] = @status WHERE (([site_id] = @Original_site_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@siteName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="siteName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_site_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="site_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="site_id" DataSetColumn="site_id" />
              <Mapping SourceColumn="siteName" DataSetColumn="siteName" />
              <Mapping SourceColumn="client_id" DataSetColumn="client_id" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Sites" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByClientID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByClientID" GeneratorSourceName="FillByClientID" GetMethodModifier="Public" GetMethodName="GetDataByClientID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByClientID" UserSourceName="FillByClientID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT client_id, siteName, site_id, status FROM Sites WHERE (client_id = @client_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="client_id" ColumnName="client_id" DataSourceName="[345671_i2iportal_db].dbo.Sites" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Sites" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySiteID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySiteID" GeneratorSourceName="FillBySiteID" GetMethodModifier="Public" GetMethodName="GetDataBySiteID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySiteID" UserSourceName="FillBySiteID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT client_id, siteName, site_id, status FROM Sites WHERE (site_id = @site_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="site_id" ColumnName="site_id" DataSourceName="[345671_i2iportal_db].dbo.Sites" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@site_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="site_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MachinesTableAdapter" GeneratorDataComponentClassName="MachinesTableAdapter" Name="Machines" UserDataComponentName="MachinesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Machines" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Machines] WHERE (([machine_id] = @Original_machine_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Machines] ([site_id], [machineName], [status], [photo], [machineType_id]) VALUES (@site_id, @machineName, @status, @photo, @machineType_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@site_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="site_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machineName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machineName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machineType_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machineType_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        machine_id, site_id, machineName, status, photo, machineType_id
FROM            Machines</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Machines] SET [site_id] = @site_id, [machineName] = @machineName, [status] = @status, [photo] = @photo, [machineType_id] = @machineType_id WHERE (([machine_id] = @Original_machine_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@site_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="site_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@machineName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="machineName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@photo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="photo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machineType_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machineType_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="site_id" DataSetColumn="site_id" />
              <Mapping SourceColumn="machineName" DataSetColumn="machineName" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="photo" DataSetColumn="photo" />
              <Mapping SourceColumn="machineType_id" DataSetColumn="machineType_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Machines" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByMachineID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMachineID" GeneratorSourceName="FillByMachineID" GetMethodModifier="Public" GetMethodName="GetDataByMachineID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMachineID" UserSourceName="FillByMachineID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        machineName, machineType_id, machine_id, photo, site_id, status
FROM            Machines
WHERE        (machine_id = @machine_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="machine_id" ColumnName="machine_id" DataSourceName="[345671_i2iportal_db].dbo.Machines" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Machines" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySiteID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySiteID" GeneratorSourceName="FillBySiteID" GetMethodModifier="Public" GetMethodName="GetDataBySiteID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySiteID" UserSourceName="FillBySiteID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT machineName, machineType_id, machine_id, photo, site_id, status FROM Machines WHERE (site_id = @site_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="site_id" ColumnName="site_id" DataSourceName="[345671_i2iportal_db].dbo.Machines" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@site_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="site_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ClientsTableAdapter" GeneratorDataComponentClassName="ClientsTableAdapter" Name="Clients" UserDataComponentName="ClientsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Clients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Clients] WHERE (([client_id] = @Original_client_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Clients] ([client_id], [clientName], [address], [contactPerson], [phoneMobile], [phoneWork], [fax], [email], [distributionEmail], [status], [parent_client_id], [paid_status], [date_registered], [licenced_start], [licenced_expired], [service_type]) VALUES (@client_id, @clientName, @address, @contactPerson, @phoneMobile, @phoneWork, @fax, @email, @distributionEmail, @status, @parent_client_id, @paid_status, @date_registered, @licenced_start, @licenced_expired, @service_type)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@clientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="clientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phoneMobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phoneMobile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phoneWork" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phoneWork" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@distributionEmail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="distributionEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@parent_client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parent_client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@paid_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="paid_status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_registered" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_registered" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@licenced_start" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="licenced_start" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@licenced_expired" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="licenced_expired" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@service_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="service_type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        client_id, clientName, address, contactPerson, phoneMobile, phoneWork, fax, email, distributionEmail, status, parent_client_id, paid_status, date_registered, 
                         licenced_start, licenced_expired, service_type
FROM            Clients</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Clients] SET [client_id] = @client_id, [clientName] = @clientName, [address] = @address, [contactPerson] = @contactPerson, [phoneMobile] = @phoneMobile, [phoneWork] = @phoneWork, [fax] = @fax, [email] = @email, [distributionEmail] = @distributionEmail, [status] = @status, [parent_client_id] = @parent_client_id, [paid_status] = @paid_status, [date_registered] = @date_registered, [licenced_start] = @licenced_start, [licenced_expired] = @licenced_expired, [service_type] = @service_type WHERE (([client_id] = @Original_client_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@clientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="clientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phoneMobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phoneMobile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@phoneWork" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="phoneWork" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@distributionEmail" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="distributionEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@parent_client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="parent_client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@paid_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="paid_status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@date_registered" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_registered" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@licenced_start" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="licenced_start" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@licenced_expired" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="licenced_expired" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@service_type" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="service_type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_client_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="client_id" DataSetColumn="client_id" />
              <Mapping SourceColumn="clientName" DataSetColumn="clientName" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="contactPerson" DataSetColumn="contactPerson" />
              <Mapping SourceColumn="phoneMobile" DataSetColumn="phoneMobile" />
              <Mapping SourceColumn="phoneWork" DataSetColumn="phoneWork" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="distributionEmail" DataSetColumn="distributionEmail" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="parent_client_id" DataSetColumn="parent_client_id" />
              <Mapping SourceColumn="paid_status" DataSetColumn="paid_status" />
              <Mapping SourceColumn="date_registered" DataSetColumn="date_registered" />
              <Mapping SourceColumn="licenced_start" DataSetColumn="licenced_start" />
              <Mapping SourceColumn="licenced_expired" DataSetColumn="licenced_expired" />
              <Mapping SourceColumn="service_type" DataSetColumn="service_type" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Clients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByClientID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByClientID" GeneratorSourceName="FillByClientID" GetMethodModifier="Public" GetMethodName="GetDataByClientID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByClientID" UserSourceName="FillByClientID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT address, clientName, client_id, contactPerson, date_registered, distributionEmail, email, fax, licenced_expired, licenced_start, paid_status, parent_client_id, phoneMobile, phoneWork, service_type, status FROM Clients WHERE (client_id = @client_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="client_id" ColumnName="client_id" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Expr3" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.Clients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySubClients" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetSubClients" GeneratorSourceName="FillBySubClients" GetMethodModifier="Public" GetMethodName="GetSubClients" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetSubClients" UserSourceName="FillBySubClients">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        client_id, clientName, address, contactPerson, phoneMobile, phoneWork, fax, email, distributionEmail, status, parent_client_id, paid_status, date_registered, 
                         licenced_start, licenced_expired, service_type
FROM            Clients WHERE (Clients.parent_client_id = @parent_client_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="parent_client_id" ColumnName="parent_client_id" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@parent_client_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="parent_client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertClient" Modifier="Public" Name="InsertClient" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertClient">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [Clients] ([client_id], [clientName], [address], [contactPerson], [phoneMobile], [phoneWork], [fax], [email], [distributionEmail], [status], [parent_client_id], [paid_status], [date_registered], [licenced_start], [licenced_expired], [service_type]) VALUES (@client_id, @clientName, @address, @contactPerson, @phoneMobile, @phoneWork, @fax, @email, @distributionEmail, @status, @parent_client_id, @paid_status, @date_registered, @licenced_start, @licenced_expired, @service_type)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="client_id" ColumnName="client_id" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@client_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="clientName" ColumnName="clientName" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@clientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="clientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="address" ColumnName="address" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(150)" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="150" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="contactPerson" ColumnName="contactPerson" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@contactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="contactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="phoneMobile" ColumnName="phoneMobile" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(15)" DbType="String" Direction="Input" ParameterName="@phoneMobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumn="phoneMobile" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="phoneWork" ColumnName="phoneWork" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(15)" DbType="String" Direction="Input" ParameterName="@phoneWork" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumn="phoneWork" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="fax" ColumnName="fax" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(15)" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="email" ColumnName="email" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="distributionEmail" ColumnName="distributionEmail" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(500)" DbType="String" Direction="Input" ParameterName="@distributionEmail" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="distributionEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="status" ColumnName="status" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(11)" DbType="String" Direction="Input" ParameterName="@status" Precision="0" ProviderType="NVarChar" Scale="0" Size="11" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="parent_client_id" ColumnName="parent_client_id" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@parent_client_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="parent_client_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="paid_status" ColumnName="paid_status" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@paid_status" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="paid_status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="date_registered" ColumnName="date_registered" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@date_registered" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="date_registered" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="licenced_start" ColumnName="licenced_start" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="nvarchar(150)" DbType="String" Direction="Input" ParameterName="@licenced_start" Precision="0" ProviderType="NVarChar" Scale="0" Size="150" SourceColumn="licenced_start" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="licenced_expired" ColumnName="licenced_expired" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="date" DbType="AnsiString" Direction="Input" ParameterName="@licenced_expired" Precision="0" ProviderType="Date" Scale="0" Size="3" SourceColumn="licenced_expired" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="service_type" ColumnName="service_type" DataSourceName="[345671_i2iportal_db].dbo.Clients" DataTypeServer="varchar(1)" DbType="AnsiString" Direction="Input" ParameterName="@service_type" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumn="service_type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CommentsOnStatusTableAdapter" GeneratorDataComponentClassName="CommentsOnStatusTableAdapter" Name="CommentsOnStatus" UserDataComponentName="CommentsOnStatusTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT StandardComments.*, Status.statusName
FROM  StandardComments INNER JOIN
               Status ON StandardComments.status_id = Status.status_id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="comment_id" DataSetColumn="comment_id" />
              <Mapping SourceColumn="commentDescription" DataSetColumn="commentDescription" />
              <Mapping SourceColumn="status_id" DataSetColumn="status_id" />
              <Mapping SourceColumn="statusName" DataSetColumn="statusName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkOrders1TableAdapter" GeneratorDataComponentClassName="WorkOrders1TableAdapter" Name="WorkOrders1" UserDataComponentName="WorkOrders1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.WorkOrders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [WorkOrders] WHERE (([workorder_id] = @Original_workorder_id) AND ((@IsNull_workorder_reference_no = 1 AND [workorder_reference_no] IS NULL) OR ([workorder_reference_no] = @Original_workorder_reference_no)) AND ([machine_id] = @Original_machine_id) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_action = 1 AND [action] IS NULL) OR ([action] = @Original_action)) AND ((@IsNull_date_submitted = 1 AND [date_submitted] IS NULL) OR ([date_submitted] = @Original_date_submitted)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_workorder_reference_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_submitted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [WorkOrders] ([workorder_reference_no], [machine_id], [description], [action], [date_submitted], [status]) VALUES (@workorder_reference_no, @machine_id, @description, @action, @date_submitted, @status);
SELECT workorder_id, workorder_reference_no, machine_id, description, action, date_submitted, status FROM WorkOrders WHERE (workorder_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        workorder_id, workorder_reference_no, machine_id, description, action, date_submitted, status
FROM            WorkOrders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [WorkOrders] SET [workorder_reference_no] = @workorder_reference_no, [machine_id] = @machine_id, [description] = @description, [action] = @action, [date_submitted] = @date_submitted, [status] = @status WHERE (([workorder_id] = @Original_workorder_id) AND ((@IsNull_workorder_reference_no = 1 AND [workorder_reference_no] IS NULL) OR ([workorder_reference_no] = @Original_workorder_reference_no)) AND ([machine_id] = @Original_machine_id) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_action = 1 AND [action] IS NULL) OR ([action] = @Original_action)) AND ((@IsNull_date_submitted = 1 AND [date_submitted] IS NULL) OR ([date_submitted] = @Original_date_submitted)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)));
SELECT workorder_id, workorder_reference_no, machine_id, description, action, date_submitted, status FROM WorkOrders WHERE (workorder_id = @workorder_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_workorder_reference_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_submitted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="workorder_id" ColumnName="workorder_id" DataSourceName="[345671_i2iportal_db].dbo.WorkOrders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="workorder_id" DataSetColumn="workorder_id" />
              <Mapping SourceColumn="workorder_reference_no" DataSetColumn="workorder_reference_no" />
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="action" DataSetColumn="action" />
              <Mapping SourceColumn="date_submitted" DataSetColumn="date_submitted" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkOrders2TableAdapter" GeneratorDataComponentClassName="WorkOrders2TableAdapter" Name="WorkOrders2" UserDataComponentName="WorkOrders2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.WorkOrders" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [WorkOrders] WHERE (([workorder_id] = @Original_workorder_id) AND ((@IsNull_workorder_reference_no = 1 AND [workorder_reference_no] IS NULL) OR ([workorder_reference_no] = @Original_workorder_reference_no)) AND ([machine_id] = @Original_machine_id) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_action = 1 AND [action] IS NULL) OR ([action] = @Original_action)) AND ((@IsNull_date_submitted = 1 AND [date_submitted] IS NULL) OR ([date_submitted] = @Original_date_submitted)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_workorder_reference_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_submitted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [WorkOrders] ([workorder_reference_no], [machine_id], [description], [action], [date_submitted], [status]) VALUES (@workorder_reference_no, @machine_id, @description, @action, @date_submitted, @status);
SELECT workorder_id, workorder_reference_no, machine_id, description, action, date_submitted, status FROM WorkOrders WHERE (workorder_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        workorder_id, workorder_reference_no, machine_id, description, action, date_submitted, status
FROM            WorkOrders</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [WorkOrders] SET [workorder_reference_no] = @workorder_reference_no, [machine_id] = @machine_id, [description] = @description, [action] = @action, [date_submitted] = @date_submitted, [status] = @status WHERE (([workorder_id] = @Original_workorder_id) AND ((@IsNull_workorder_reference_no = 1 AND [workorder_reference_no] IS NULL) OR ([workorder_reference_no] = @Original_workorder_reference_no)) AND ([machine_id] = @Original_machine_id) AND ((@IsNull_description = 1 AND [description] IS NULL) OR ([description] = @Original_description)) AND ((@IsNull_action = 1 AND [action] IS NULL) OR ([action] = @Original_action)) AND ((@IsNull_date_submitted = 1 AND [date_submitted] IS NULL) OR ([date_submitted] = @Original_date_submitted)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)));
SELECT workorder_id, workorder_reference_no, machine_id, description, action, date_submitted, status FROM WorkOrders WHERE (workorder_id = @workorder_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_workorder_reference_no" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_workorder_reference_no" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="workorder_reference_no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_machine_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="machine_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_action" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_action" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="action" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_date_submitted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_date_submitted" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="date_submitted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="workorder_id" ColumnName="workorder_id" DataSourceName="[345671_i2iportal_db].dbo.WorkOrders" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@workorder_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="workorder_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="workorder_id" DataSetColumn="workorder_id" />
              <Mapping SourceColumn="workorder_reference_no" DataSetColumn="workorder_reference_no" />
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="action" DataSetColumn="action" />
              <Mapping SourceColumn="date_submitted" DataSetColumn="date_submitted" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TestInterValTableAdapter" GeneratorDataComponentClassName="TestInterValTableAdapter" Name="TestInterVal" UserDataComponentName="TestInterValTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.TestInterVal" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetTestInterval" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetTestInterval" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetTestInterval" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [TestInterVal] WHERE (([Interval_Id] = @Original_Interval_Id) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_CompanyID = 1 AND [CompanyID] IS NULL) OR ([CompanyID] = @Original_CompanyID)) AND ((@IsNull_Site_ID = 1 AND [Site_ID] IS NULL) OR ([Site_ID] = @Original_Site_ID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Interval_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Interval_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Site_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [TestInterVal] ([Name], [CompanyID], [Site_ID]) VALUES (@Name, @CompanyID, @Site_ID);
SELECT Interval_Id, Name, CompanyID, Site_ID FROM TestInterVal AS t WHERE (Interval_Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Site_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  Interval_Id, Name, CompanyID, Site_ID
FROM      TestInterVal t where (t.CompanyID = @CompanyID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="CompanyID" ColumnName="CompanyID" DataSourceName="[345671_i2iportal_db].dbo.TestInterVal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [TestInterVal] SET [Name] = @Name, [CompanyID] = @CompanyID, [Site_ID] = @Site_ID WHERE (([Interval_Id] = @Original_Interval_Id) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_CompanyID = 1 AND [CompanyID] IS NULL) OR ([CompanyID] = @Original_CompanyID)) AND ((@IsNull_Site_ID = 1 AND [Site_ID] IS NULL) OR ([Site_ID] = @Original_Site_ID)));
SELECT Interval_Id, Name, CompanyID, Site_ID FROM TestInterVal AS t WHERE (Interval_Id = @Interval_Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Site_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Interval_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Interval_Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CompanyID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompanyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Site_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Site_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Site_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Interval_Id" ColumnName="Interval_Id" DataSourceName="[345671_i2iportal_db].dbo.TestInterVal" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Interval_Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Interval_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Interval_Id" DataSetColumn="Interval_Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="CompanyID" DataSetColumn="CompanyID" />
              <Mapping SourceColumn="Site_ID" DataSetColumn="Site_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MachinesOnSitesTableAdapter" GeneratorDataComponentClassName="MachinesOnSitesTableAdapter" Name="MachinesOnSites" UserDataComponentName="MachinesOnSitesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  m.machine_id, m.site_id, m.machineName, m.status, m.photo, m.machineType_id, s.site_id AS Expr1, s.siteName, s.client_id, 
                   s.status AS Expr2
FROM      Machines AS m INNER JOIN
                   Sites AS s ON m.site_id = s.site_id</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="machine_id" DataSetColumn="machine_id" />
              <Mapping SourceColumn="site_id" DataSetColumn="site_id" />
              <Mapping SourceColumn="machineName" DataSetColumn="machineName" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="photo" DataSetColumn="photo" />
              <Mapping SourceColumn="machineType_id" DataSetColumn="machineType_id" />
              <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
              <Mapping SourceColumn="siteName" DataSetColumn="siteName" />
              <Mapping SourceColumn="client_id" DataSetColumn="client_id" />
              <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetMachinesBySiteId" GetMethodModifier="Public" GetMethodName="GetMachinesBySiteId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetMachinesBySiteId" UserSourceName="GetMachinesBySiteId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT  m.machine_id, m.site_id, m.machineName, m.status, m.photo, m.machineType_id, s.site_id AS Expr1, s.siteName, s.client_id, 
                   s.status AS Expr2
FROM      Machines AS m INNER JOIN
                   Sites AS s ON m.site_id = s.site_id where s.site_id = @site_Id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="site_Id" ColumnName="site_id" DataSourceName="[345671_i2iportal_db].dbo.Sites" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@site_Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Expr1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OilReportsTableAdapter" GeneratorDataComponentClassName="OilReportsTableAdapter" Name="OilReports" UserDataComponentName="OilReportsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.OilReports" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetOilReportsByComponentID" GetMethodModifier="Public" GetMethodName="GetOilReportsByComponentID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetOilReportsByComponentID" UserSourceName="GetOilReportsByComponentID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [oilreports] WHERE (((@IsNull_sample_id = 1 AND [sample_id] IS NULL) OR ([sample_id] = @Original_sample_id)) AND ([Component_id] = @Original_Component_id) AND ((@IsNull_receive_date = 1 AND [receive_date] IS NULL) OR ([receive_date] = @Original_receive_date)) AND ((@IsNull_tested_date = 1 AND [tested_date] IS NULL) OR ([tested_date] = @Original_tested_date)) AND ((@IsNull_reportlink = 1 AND [reportlink] IS NULL) OR ([reportlink] = @Original_reportlink)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_receive_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tested_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reportlink" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [oilreports] ([sample_id], [Component_id], [receive_date], [tested_date], [reportlink], [status]) VALUES (@sample_id, @Component_id, @receive_date, @tested_date, @reportlink, @status);
SELECT sample_id, Component_id, receive_date, tested_date, reportlink, status, id FROM OilReports WHERE (id = SCOPE_IDENTITY()) ORDER BY tested_date DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select * from oilreports where component_id  = @component_id order by tested_date desc</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="Component_id" DataSourceName="[345671_i2iportal_db].dbo.OilReports" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [oilreports] SET [sample_id] = @sample_id, [Component_id] = @Component_id, [receive_date] = @receive_date, [tested_date] = @tested_date, [reportlink] = @reportlink, [status] = @status WHERE (((@IsNull_sample_id = 1 AND [sample_id] IS NULL) OR ([sample_id] = @Original_sample_id)) AND ([Component_id] = @Original_Component_id) AND ((@IsNull_receive_date = 1 AND [receive_date] IS NULL) OR ([receive_date] = @Original_receive_date)) AND ((@IsNull_tested_date = 1 AND [tested_date] IS NULL) OR ([tested_date] = @Original_tested_date)) AND ((@IsNull_reportlink = 1 AND [reportlink] IS NULL) OR ([reportlink] = @Original_reportlink)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ([id] = @Original_id));
SELECT sample_id, Component_id, receive_date, tested_date, reportlink, status, id FROM OilReports WHERE (id = @id) ORDER BY tested_date DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_receive_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tested_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reportlink" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="[345671_i2iportal_db].dbo.OilReports" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="sample_id" DataSetColumn="sample_id" />
              <Mapping SourceColumn="Component_id" DataSetColumn="Component_id" />
              <Mapping SourceColumn="receive_date" DataSetColumn="receive_date" />
              <Mapping SourceColumn="tested_date" DataSetColumn="tested_date" />
              <Mapping SourceColumn="reportlink" DataSetColumn="reportlink" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DAOilReportsTableAdapter" GeneratorDataComponentClassName="DAOilReportsTableAdapter" Name="DAOilReports" UserDataComponentName="DAOilReportsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="[345671_i2iportal_db].dbo.OilReports" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetOilReportsRecordByID" GetMethodModifier="Public" GetMethodName="GetOilReportsRecordByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetOilReportsRecordByID" UserSourceName="GetOilReportsRecordByID">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [OilReports] WHERE (((@IsNull_sample_id = 1 AND [sample_id] IS NULL) OR ([sample_id] = @Original_sample_id)) AND ([Component_id] = @Original_Component_id) AND ((@IsNull_receive_date = 1 AND [receive_date] IS NULL) OR ([receive_date] = @Original_receive_date)) AND ((@IsNull_tested_date = 1 AND [tested_date] IS NULL) OR ([tested_date] = @Original_tested_date)) AND ((@IsNull_reportlink = 1 AND [reportlink] IS NULL) OR ([reportlink] = @Original_reportlink)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_receive_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tested_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reportlink" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [OilReports] ([sample_id], [Component_id], [receive_date], [tested_date], [reportlink], [status]) VALUES (@sample_id, @Component_id, @receive_date, @tested_date, @reportlink, @status);
SELECT sample_id, Component_id, receive_date, tested_date, reportlink, status, id FROM OilReports WHERE (id = SCOPE_IDENTITY()) ORDER BY tested_date DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select * from OilReports where component_id = @component_id order by tested_date desc</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="component_id" ColumnName="Component_id" DataSourceName="[345671_i2iportal_db].dbo.OilReports" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@component_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [OilReports] SET [sample_id] = @sample_id, [Component_id] = @Component_id, [receive_date] = @receive_date, [tested_date] = @tested_date, [reportlink] = @reportlink, [status] = @status WHERE (((@IsNull_sample_id = 1 AND [sample_id] IS NULL) OR ([sample_id] = @Original_sample_id)) AND ([Component_id] = @Original_Component_id) AND ((@IsNull_receive_date = 1 AND [receive_date] IS NULL) OR ([receive_date] = @Original_receive_date)) AND ((@IsNull_tested_date = 1 AND [tested_date] IS NULL) OR ([tested_date] = @Original_tested_date)) AND ((@IsNull_reportlink = 1 AND [reportlink] IS NULL) OR ([reportlink] = @Original_reportlink)) AND ((@IsNull_status = 1 AND [status] IS NULL) OR ([status] = @Original_status)) AND ([id] = @Original_id));
SELECT sample_id, Component_id, receive_date, tested_date, reportlink, status, id FROM OilReports WHERE (id = @id) ORDER BY tested_date DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_sample_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sample_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Component_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Component_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_receive_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_receive_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="receive_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tested_date" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_tested_date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="tested_date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_reportlink" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_reportlink" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="reportlink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_status" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_status" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="status" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="[345671_i2iportal_db].dbo.OilReports" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="sample_id" DataSetColumn="sample_id" />
              <Mapping SourceColumn="Component_id" DataSetColumn="Component_id" />
              <Mapping SourceColumn="receive_date" DataSetColumn="receive_date" />
              <Mapping SourceColumn="tested_date" DataSetColumn="tested_date" />
              <Mapping SourceColumn="reportlink" DataSetColumn="reportlink" />
              <Mapping SourceColumn="status" DataSetColumn="status" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="i2iPortal" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="i2iPortal" msprop:Generator_DataSetName="i2iPortal" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Users" msprop:Generator_UserTableName="Users" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_TablePropName="Users">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="user_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="user_id" msprop:Generator_ColumnPropNameInRow="user_id" msprop:Generator_ColumnVarNameInTable="columnuser_id" msprop:Generator_ColumnPropNameInTable="user_idColumn" type="xs:int" />
              <xs:element name="username" msprop:Generator_UserColumnName="username" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInTable="usernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_UserColumnName="password" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInTable="passwordColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="is_admin" msprop:Generator_UserColumnName="is_admin" msprop:Generator_ColumnPropNameInRow="is_admin" msprop:Generator_ColumnVarNameInTable="columnis_admin" msprop:Generator_ColumnPropNameInTable="is_adminColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="9" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="role" msprop:Generator_UserColumnName="role" msprop:Generator_ColumnPropNameInRow="role" msprop:Generator_ColumnVarNameInTable="columnrole" msprop:Generator_ColumnPropNameInTable="roleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="client_id" msprop:Generator_UserColumnName="client_id" msprop:Generator_ColumnPropNameInRow="client_id" msprop:Generator_ColumnVarNameInTable="columnclient_id" msprop:Generator_ColumnPropNameInTable="client_idColumn" type="xs:int" />
              <xs:element name="name" msprop:Generator_UserColumnName="name" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInTable="nameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Components" msprop:Generator_UserTableName="Components" msprop:Generator_RowDeletedName="ComponentsRowDeleted" msprop:Generator_RowChangedName="ComponentsRowChanged" msprop:Generator_RowClassName="ComponentsRow" msprop:Generator_RowChangingName="ComponentsRowChanging" msprop:Generator_RowEvArgName="ComponentsRowChangeEvent" msprop:Generator_RowEvHandlerName="ComponentsRowChangeEventHandler" msprop:Generator_TableClassName="ComponentsDataTable" msprop:Generator_TableVarName="tableComponents" msprop:Generator_RowDeletingName="ComponentsRowDeleting" msprop:Generator_TablePropName="Components">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="component_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="component_id" msprop:Generator_ColumnPropNameInRow="component_id" msprop:Generator_ColumnVarNameInTable="columncomponent_id" msprop:Generator_ColumnPropNameInTable="component_idColumn" type="xs:int" />
              <xs:element name="machine_id" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="componentName" msprop:Generator_UserColumnName="componentName" msprop:Generator_ColumnPropNameInRow="componentName" msprop:Generator_ColumnVarNameInTable="columncomponentName" msprop:Generator_ColumnPropNameInTable="componentNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="category_id" msprop:Generator_UserColumnName="category_id" msprop:Generator_ColumnVarNameInTable="columncategory_id" msprop:Generator_ColumnPropNameInRow="category_id" msprop:Generator_ColumnPropNameInTable="category_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Interval_Id" msprop:Generator_UserColumnName="Interval_Id" msprop:Generator_ColumnPropNameInRow="Interval_Id" msprop:Generator_ColumnVarNameInTable="columnInterval_Id" msprop:Generator_ColumnPropNameInTable="Interval_IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="InterValName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="InterValName" msprop:Generator_ColumnPropNameInRow="InterValName" msprop:Generator_ColumnVarNameInTable="columnInterValName" msprop:Generator_ColumnPropNameInTable="InterValNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkOrders" msprop:Generator_UserTableName="WorkOrders" msprop:Generator_RowDeletedName="WorkOrdersRowDeleted" msprop:Generator_RowChangedName="WorkOrdersRowChanged" msprop:Generator_RowClassName="WorkOrdersRow" msprop:Generator_RowChangingName="WorkOrdersRowChanging" msprop:Generator_RowEvArgName="WorkOrdersRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrdersRowChangeEventHandler" msprop:Generator_TableClassName="WorkOrdersDataTable" msprop:Generator_TableVarName="tableWorkOrders" msprop:Generator_RowDeletingName="WorkOrdersRowDeleting" msprop:Generator_TablePropName="WorkOrders">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="workorder_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="workorder_id" msprop:Generator_ColumnPropNameInRow="workorder_id" msprop:Generator_ColumnVarNameInTable="columnworkorder_id" msprop:Generator_ColumnPropNameInTable="workorder_idColumn" type="xs:int" />
              <xs:element name="workorder_reference_no" msprop:Generator_UserColumnName="workorder_reference_no" msprop:Generator_ColumnPropNameInRow="workorder_reference_no" msprop:Generator_ColumnVarNameInTable="columnworkorder_reference_no" msprop:Generator_ColumnPropNameInTable="workorder_reference_noColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machine_id" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="action" msprop:Generator_UserColumnName="action" msprop:Generator_ColumnPropNameInRow="action" msprop:Generator_ColumnVarNameInTable="columnaction" msprop:Generator_ColumnPropNameInTable="actionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_submitted" msprop:Generator_UserColumnName="date_submitted" msprop:Generator_ColumnPropNameInRow="date_submitted" msprop:Generator_ColumnVarNameInTable="columndate_submitted" msprop:Generator_ColumnPropNameInTable="date_submittedColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Status" msprop:Generator_UserTableName="Status" msprop:Generator_RowDeletedName="StatusRowDeleted" msprop:Generator_RowChangedName="StatusRowChanged" msprop:Generator_RowClassName="StatusRow" msprop:Generator_RowChangingName="StatusRowChanging" msprop:Generator_RowEvArgName="StatusRowChangeEvent" msprop:Generator_RowEvHandlerName="StatusRowChangeEventHandler" msprop:Generator_TableClassName="StatusDataTable" msprop:Generator_TableVarName="tableStatus" msprop:Generator_RowDeletingName="StatusRowDeleting" msprop:Generator_TablePropName="Status">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="status_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="status_id" msprop:Generator_ColumnPropNameInRow="status_id" msprop:Generator_ColumnVarNameInTable="columnstatus_id" msprop:Generator_ColumnPropNameInTable="status_idColumn" type="xs:int" />
              <xs:element name="statusName" msprop:Generator_UserColumnName="statusName" msprop:Generator_ColumnPropNameInRow="statusName" msprop:Generator_ColumnVarNameInTable="columnstatusName" msprop:Generator_ColumnPropNameInTable="statusNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="statusDescription" msprop:Generator_UserColumnName="statusDescription" msprop:Generator_ColumnPropNameInRow="statusDescription" msprop:Generator_ColumnVarNameInTable="columnstatusDescription" msprop:Generator_ColumnPropNameInTable="statusDescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ComponentStatus" msprop:Generator_UserTableName="ComponentStatus" msprop:Generator_RowDeletedName="ComponentStatusRowDeleted" msprop:Generator_RowChangedName="ComponentStatusRowChanged" msprop:Generator_RowClassName="ComponentStatusRow" msprop:Generator_RowChangingName="ComponentStatusRowChanging" msprop:Generator_RowEvArgName="ComponentStatusRowChangeEvent" msprop:Generator_RowEvHandlerName="ComponentStatusRowChangeEventHandler" msprop:Generator_TableClassName="ComponentStatusDataTable" msprop:Generator_TableVarName="tableComponentStatus" msprop:Generator_RowDeletingName="ComponentStatusRowDeleting" msprop:Generator_TablePropName="ComponentStatus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="component_id" msprop:Generator_UserColumnName="component_id" msprop:Generator_ColumnVarNameInTable="columncomponent_id" msprop:Generator_ColumnPropNameInRow="component_id" msprop:Generator_ColumnPropNameInTable="component_idColumn" type="xs:int" />
              <xs:element name="status_id" msprop:Generator_UserColumnName="status_id" msprop:Generator_ColumnVarNameInTable="columnstatus_id" msprop:Generator_ColumnPropNameInRow="status_id" msprop:Generator_ColumnPropNameInTable="status_idColumn" type="xs:int" />
              <xs:element name="comments" msprop:Generator_UserColumnName="comments" msprop:Generator_ColumnVarNameInTable="columncomments" msprop:Generator_ColumnPropNameInRow="comments" msprop:Generator_ColumnPropNameInTable="commentsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateRecorded" msprop:Generator_UserColumnName="dateRecorded" msprop:Generator_ColumnVarNameInTable="columndateRecorded" msprop:Generator_ColumnPropNameInRow="dateRecorded" msprop:Generator_ColumnPropNameInTable="dateRecordedColumn" type="xs:dateTime" />
              <xs:element name="dateEntered" msprop:Generator_UserColumnName="dateEntered" msprop:Generator_ColumnVarNameInTable="columndateEntered" msprop:Generator_ColumnPropNameInRow="dateEntered" msprop:Generator_ColumnPropNameInTable="dateEnteredColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="comment_id" msprop:Generator_UserColumnName="comment_id" msprop:Generator_ColumnVarNameInTable="columncomment_id" msprop:Generator_ColumnPropNameInRow="comment_id" msprop:Generator_ColumnPropNameInTable="comment_idColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="StandardComments" msprop:Generator_UserTableName="StandardComments" msprop:Generator_RowDeletedName="StandardCommentsRowDeleted" msprop:Generator_RowChangedName="StandardCommentsRowChanged" msprop:Generator_RowClassName="StandardCommentsRow" msprop:Generator_RowChangingName="StandardCommentsRowChanging" msprop:Generator_RowEvArgName="StandardCommentsRowChangeEvent" msprop:Generator_RowEvHandlerName="StandardCommentsRowChangeEventHandler" msprop:Generator_TableClassName="StandardCommentsDataTable" msprop:Generator_TableVarName="tableStandardComments" msprop:Generator_RowDeletingName="StandardCommentsRowDeleting" msprop:Generator_TablePropName="StandardComments">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="comment_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="comment_id" msprop:Generator_ColumnPropNameInRow="comment_id" msprop:Generator_ColumnVarNameInTable="columncomment_id" msprop:Generator_ColumnPropNameInTable="comment_idColumn" type="xs:int" />
              <xs:element name="commentDescription" msprop:Generator_UserColumnName="commentDescription" msprop:Generator_ColumnPropNameInRow="commentDescription" msprop:Generator_ColumnVarNameInTable="columncommentDescription" msprop:Generator_ColumnPropNameInTable="commentDescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status_id" msprop:Generator_UserColumnName="status_id" msprop:Generator_ColumnPropNameInRow="status_id" msprop:Generator_ColumnVarNameInTable="columnstatus_id" msprop:Generator_ColumnPropNameInTable="status_idColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SitesOnClients" msprop:Generator_UserTableName="SitesOnClients" msprop:Generator_RowDeletedName="SitesOnClientsRowDeleted" msprop:Generator_RowChangedName="SitesOnClientsRowChanged" msprop:Generator_RowClassName="SitesOnClientsRow" msprop:Generator_RowChangingName="SitesOnClientsRowChanging" msprop:Generator_RowEvArgName="SitesOnClientsRowChangeEvent" msprop:Generator_RowEvHandlerName="SitesOnClientsRowChangeEventHandler" msprop:Generator_TableClassName="SitesOnClientsDataTable" msprop:Generator_TableVarName="tableSitesOnClients" msprop:Generator_RowDeletingName="SitesOnClientsRowDeleting" msprop:Generator_TablePropName="SitesOnClients">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="site_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="site_id" msprop:Generator_ColumnPropNameInRow="site_id" msprop:Generator_ColumnVarNameInTable="columnsite_id" msprop:Generator_ColumnPropNameInTable="site_idColumn" type="xs:int" />
              <xs:element name="siteName" msprop:Generator_UserColumnName="siteName" msprop:Generator_ColumnPropNameInRow="siteName" msprop:Generator_ColumnVarNameInTable="columnsiteName" msprop:Generator_ColumnPropNameInTable="siteNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="client_id" msprop:Generator_UserColumnName="client_id" msprop:Generator_ColumnPropNameInRow="client_id" msprop:Generator_ColumnVarNameInTable="columnclient_id" msprop:Generator_ColumnPropNameInTable="client_idColumn" type="xs:int" />
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="clientName" msprop:Generator_UserColumnName="clientName" msprop:Generator_ColumnPropNameInRow="clientName" msprop:Generator_ColumnVarNameInTable="columnclientName" msprop:Generator_ColumnPropNameInTable="clientNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ComponentsOnMachines" msprop:Generator_UserTableName="ComponentsOnMachines" msprop:Generator_RowDeletedName="ComponentsOnMachinesRowDeleted" msprop:Generator_RowChangedName="ComponentsOnMachinesRowChanged" msprop:Generator_RowClassName="ComponentsOnMachinesRow" msprop:Generator_RowChangingName="ComponentsOnMachinesRowChanging" msprop:Generator_RowEvArgName="ComponentsOnMachinesRowChangeEvent" msprop:Generator_RowEvHandlerName="ComponentsOnMachinesRowChangeEventHandler" msprop:Generator_TableClassName="ComponentsOnMachinesDataTable" msprop:Generator_TableVarName="tableComponentsOnMachines" msprop:Generator_RowDeletingName="ComponentsOnMachinesRowDeleting" msprop:Generator_TablePropName="ComponentsOnMachines">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="component_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="component_id" msprop:Generator_ColumnPropNameInRow="component_id" msprop:Generator_ColumnVarNameInTable="columncomponent_id" msprop:Generator_ColumnPropNameInTable="component_idColumn" type="xs:int" />
              <xs:element name="machine_id" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="componentName" msprop:Generator_UserColumnName="componentName" msprop:Generator_ColumnPropNameInRow="componentName" msprop:Generator_ColumnVarNameInTable="columncomponentName" msprop:Generator_ColumnPropNameInTable="componentNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machineName" msprop:Generator_UserColumnName="machineName" msprop:Generator_ColumnPropNameInRow="machineName" msprop:Generator_ColumnVarNameInTable="columnmachineName" msprop:Generator_ColumnPropNameInTable="machineNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="siteName" msprop:Generator_UserColumnName="siteName" msprop:Generator_ColumnPropNameInRow="siteName" msprop:Generator_ColumnVarNameInTable="columnsiteName" msprop:Generator_ColumnPropNameInTable="siteNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ComponentStatusOnComponents" msprop:Generator_UserTableName="ComponentStatusOnComponents" msprop:Generator_RowDeletedName="ComponentStatusOnComponentsRowDeleted" msprop:Generator_RowChangedName="ComponentStatusOnComponentsRowChanged" msprop:Generator_RowClassName="ComponentStatusOnComponentsRow" msprop:Generator_RowChangingName="ComponentStatusOnComponentsRowChanging" msprop:Generator_RowEvArgName="ComponentStatusOnComponentsRowChangeEvent" msprop:Generator_RowEvHandlerName="ComponentStatusOnComponentsRowChangeEventHandler" msprop:Generator_TableClassName="ComponentStatusOnComponentsDataTable" msprop:Generator_TableVarName="tableComponentStatusOnComponents" msprop:Generator_RowDeletingName="ComponentStatusOnComponentsRowDeleting" msprop:Generator_TablePropName="ComponentStatusOnComponents">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="component_id" msprop:Generator_UserColumnName="component_id" msprop:Generator_ColumnPropNameInRow="component_id" msprop:Generator_ColumnVarNameInTable="columncomponent_id" msprop:Generator_ColumnPropNameInTable="component_idColumn" type="xs:int" />
              <xs:element name="status_id" msprop:Generator_UserColumnName="status_id" msprop:Generator_ColumnPropNameInRow="status_id" msprop:Generator_ColumnVarNameInTable="columnstatus_id" msprop:Generator_ColumnPropNameInTable="status_idColumn" type="xs:int" />
              <xs:element name="comments" msprop:Generator_UserColumnName="comments" msprop:Generator_ColumnPropNameInRow="comments" msprop:Generator_ColumnVarNameInTable="columncomments" msprop:Generator_ColumnPropNameInTable="commentsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateRecorded" msprop:Generator_UserColumnName="dateRecorded" msprop:Generator_ColumnPropNameInRow="dateRecorded" msprop:Generator_ColumnVarNameInTable="columndateRecorded" msprop:Generator_ColumnPropNameInTable="dateRecordedColumn" type="xs:dateTime" />
              <xs:element name="dateEntered" msprop:Generator_UserColumnName="dateEntered" msprop:Generator_ColumnPropNameInRow="dateEntered" msprop:Generator_ColumnVarNameInTable="columndateEntered" msprop:Generator_ColumnPropNameInTable="dateEnteredColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="comment_id" msprop:Generator_UserColumnName="comment_id" msprop:Generator_ColumnPropNameInRow="comment_id" msprop:Generator_ColumnVarNameInTable="columncomment_id" msprop:Generator_ColumnPropNameInTable="comment_idColumn" type="xs:int" />
              <xs:element name="componentName" msprop:Generator_UserColumnName="componentName" msprop:Generator_ColumnPropNameInRow="componentName" msprop:Generator_ColumnVarNameInTable="columncomponentName" msprop:Generator_ColumnPropNameInTable="componentNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="statusName" msprop:Generator_UserColumnName="statusName" msprop:Generator_ColumnPropNameInRow="statusName" msprop:Generator_ColumnVarNameInTable="columnstatusName" msprop:Generator_ColumnPropNameInTable="statusNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="commentDescription" msprop:Generator_UserColumnName="commentDescription" msprop:Generator_ColumnPropNameInRow="commentDescription" msprop:Generator_ColumnVarNameInTable="columncommentDescription" msprop:Generator_ColumnPropNameInTable="commentDescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkOrdersOnMachines" msprop:Generator_UserTableName="WorkOrdersOnMachines" msprop:Generator_RowDeletedName="WorkOrdersOnMachinesRowDeleted" msprop:Generator_RowChangedName="WorkOrdersOnMachinesRowChanged" msprop:Generator_RowClassName="WorkOrdersOnMachinesRow" msprop:Generator_RowChangingName="WorkOrdersOnMachinesRowChanging" msprop:Generator_RowEvArgName="WorkOrdersOnMachinesRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrdersOnMachinesRowChangeEventHandler" msprop:Generator_TableClassName="WorkOrdersOnMachinesDataTable" msprop:Generator_TableVarName="tableWorkOrdersOnMachines" msprop:Generator_RowDeletingName="WorkOrdersOnMachinesRowDeleting" msprop:Generator_TablePropName="WorkOrdersOnMachines">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="workorder_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="workorder_id" msprop:Generator_ColumnPropNameInRow="workorder_id" msprop:Generator_ColumnVarNameInTable="columnworkorder_id" msprop:Generator_ColumnPropNameInTable="workorder_idColumn" type="xs:int" />
              <xs:element name="workorder_reference_no" msprop:Generator_UserColumnName="workorder_reference_no" msprop:Generator_ColumnPropNameInRow="workorder_reference_no" msprop:Generator_ColumnVarNameInTable="columnworkorder_reference_no" msprop:Generator_ColumnPropNameInTable="workorder_reference_noColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machine_id" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="action" msprop:Generator_UserColumnName="action" msprop:Generator_ColumnPropNameInRow="action" msprop:Generator_ColumnVarNameInTable="columnaction" msprop:Generator_ColumnPropNameInTable="actionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_submitted" msprop:Generator_UserColumnName="date_submitted" msprop:Generator_ColumnPropNameInRow="date_submitted" msprop:Generator_ColumnVarNameInTable="columndate_submitted" msprop:Generator_ColumnPropNameInTable="date_submittedColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machineName" msprop:Generator_UserColumnName="machineName" msprop:Generator_ColumnPropNameInRow="machineName" msprop:Generator_ColumnVarNameInTable="columnmachineName" msprop:Generator_ColumnPropNameInTable="machineNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Sites" msprop:Generator_UserTableName="Sites" msprop:Generator_RowDeletedName="SitesRowDeleted" msprop:Generator_RowChangedName="SitesRowChanged" msprop:Generator_RowClassName="SitesRow" msprop:Generator_RowChangingName="SitesRowChanging" msprop:Generator_RowEvArgName="SitesRowChangeEvent" msprop:Generator_RowEvHandlerName="SitesRowChangeEventHandler" msprop:Generator_TableClassName="SitesDataTable" msprop:Generator_TableVarName="tableSites" msprop:Generator_RowDeletingName="SitesRowDeleting" msprop:Generator_TablePropName="Sites">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="site_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="site_id" msprop:Generator_ColumnPropNameInRow="site_id" msprop:Generator_ColumnVarNameInTable="columnsite_id" msprop:Generator_ColumnPropNameInTable="site_idColumn" type="xs:int" />
              <xs:element name="siteName" msprop:Generator_UserColumnName="siteName" msprop:Generator_ColumnPropNameInRow="siteName" msprop:Generator_ColumnVarNameInTable="columnsiteName" msprop:Generator_ColumnPropNameInTable="siteNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="client_id" msprop:Generator_UserColumnName="client_id" msprop:Generator_ColumnPropNameInRow="client_id" msprop:Generator_ColumnVarNameInTable="columnclient_id" msprop:Generator_ColumnPropNameInTable="client_idColumn" type="xs:int" />
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Machines" msprop:Generator_UserTableName="Machines" msprop:Generator_RowDeletedName="MachinesRowDeleted" msprop:Generator_RowChangedName="MachinesRowChanged" msprop:Generator_RowClassName="MachinesRow" msprop:Generator_RowChangingName="MachinesRowChanging" msprop:Generator_RowEvArgName="MachinesRowChangeEvent" msprop:Generator_RowEvHandlerName="MachinesRowChangeEventHandler" msprop:Generator_TableClassName="MachinesDataTable" msprop:Generator_TableVarName="tableMachines" msprop:Generator_RowDeletingName="MachinesRowDeleting" msprop:Generator_TablePropName="Machines">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="machine_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="site_id" msprop:Generator_UserColumnName="site_id" msprop:Generator_ColumnPropNameInRow="site_id" msprop:Generator_ColumnVarNameInTable="columnsite_id" msprop:Generator_ColumnPropNameInTable="site_idColumn" type="xs:int" />
              <xs:element name="machineName" msprop:Generator_UserColumnName="machineName" msprop:Generator_ColumnPropNameInRow="machineName" msprop:Generator_ColumnVarNameInTable="columnmachineName" msprop:Generator_ColumnPropNameInTable="machineNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="photo" msprop:Generator_UserColumnName="photo" msprop:Generator_ColumnPropNameInRow="photo" msprop:Generator_ColumnVarNameInTable="columnphoto" msprop:Generator_ColumnPropNameInTable="photoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machineType_id" msprop:Generator_UserColumnName="machineType_id" msprop:Generator_ColumnVarNameInTable="columnmachineType_id" msprop:Generator_ColumnPropNameInRow="machineType_id" msprop:Generator_ColumnPropNameInTable="machineType_idColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Clients" msprop:Generator_UserTableName="Clients" msprop:Generator_RowDeletedName="ClientsRowDeleted" msprop:Generator_RowChangedName="ClientsRowChanged" msprop:Generator_RowClassName="ClientsRow" msprop:Generator_RowChangingName="ClientsRowChanging" msprop:Generator_RowEvArgName="ClientsRowChangeEvent" msprop:Generator_RowEvHandlerName="ClientsRowChangeEventHandler" msprop:Generator_TableClassName="ClientsDataTable" msprop:Generator_TableVarName="tableClients" msprop:Generator_RowDeletingName="ClientsRowDeleting" msprop:Generator_TablePropName="Clients">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="client_id" msprop:Generator_UserColumnName="client_id" msprop:Generator_ColumnPropNameInRow="client_id" msprop:Generator_ColumnVarNameInTable="columnclient_id" msprop:Generator_ColumnPropNameInTable="client_idColumn" type="xs:int" />
              <xs:element name="clientName" msprop:Generator_UserColumnName="clientName" msprop:Generator_ColumnPropNameInRow="clientName" msprop:Generator_ColumnVarNameInTable="columnclientName" msprop:Generator_ColumnPropNameInTable="clientNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address" msprop:Generator_UserColumnName="address" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInTable="addressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contactPerson" msprop:Generator_UserColumnName="contactPerson" msprop:Generator_ColumnPropNameInRow="contactPerson" msprop:Generator_ColumnVarNameInTable="columncontactPerson" msprop:Generator_ColumnPropNameInTable="contactPersonColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="phoneMobile" msprop:Generator_UserColumnName="phoneMobile" msprop:Generator_ColumnPropNameInRow="phoneMobile" msprop:Generator_ColumnVarNameInTable="columnphoneMobile" msprop:Generator_ColumnPropNameInTable="phoneMobileColumn" type="xs:string" minOccurs="0" />
              <xs:element name="phoneWork" msprop:Generator_UserColumnName="phoneWork" msprop:Generator_ColumnPropNameInRow="phoneWork" msprop:Generator_ColumnVarNameInTable="columnphoneWork" msprop:Generator_ColumnPropNameInTable="phoneWorkColumn" type="xs:string" minOccurs="0" />
              <xs:element name="fax" msprop:Generator_UserColumnName="fax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInTable="faxColumn" type="xs:string" minOccurs="0" />
              <xs:element name="email" msprop:Generator_UserColumnName="email" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInTable="emailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="distributionEmail" msprop:Generator_UserColumnName="distributionEmail" msprop:Generator_ColumnPropNameInRow="distributionEmail" msprop:Generator_ColumnVarNameInTable="columndistributionEmail" msprop:Generator_ColumnPropNameInTable="distributionEmailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="parent_client_id" msprop:Generator_UserColumnName="parent_client_id" msprop:Generator_ColumnPropNameInRow="parent_client_id" msprop:Generator_ColumnVarNameInTable="columnparent_client_id" msprop:Generator_ColumnPropNameInTable="parent_client_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="paid_status" msprop:Generator_UserColumnName="paid_status" msprop:Generator_ColumnPropNameInRow="paid_status" msprop:Generator_ColumnVarNameInTable="columnpaid_status" msprop:Generator_ColumnPropNameInTable="paid_statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_registered" msprop:Generator_UserColumnName="date_registered" msprop:Generator_ColumnPropNameInRow="date_registered" msprop:Generator_ColumnVarNameInTable="columndate_registered" msprop:Generator_ColumnPropNameInTable="date_registeredColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="licenced_start" msprop:Generator_UserColumnName="licenced_start" msprop:Generator_ColumnPropNameInRow="licenced_start" msprop:Generator_ColumnVarNameInTable="columnlicenced_start" msprop:Generator_ColumnPropNameInTable="licenced_startColumn" type="xs:string" minOccurs="0" />
              <xs:element name="licenced_expired" msprop:Generator_UserColumnName="licenced_expired" msprop:Generator_ColumnPropNameInRow="licenced_expired" msprop:Generator_ColumnVarNameInTable="columnlicenced_expired" msprop:Generator_ColumnPropNameInTable="licenced_expiredColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="service_type" msprop:Generator_UserColumnName="service_type" msprop:Generator_ColumnPropNameInRow="service_type" msprop:Generator_ColumnVarNameInTable="columnservice_type" msprop:Generator_ColumnPropNameInTable="service_typeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CommentsOnStatus" msprop:Generator_UserTableName="CommentsOnStatus" msprop:Generator_RowDeletedName="CommentsOnStatusRowDeleted" msprop:Generator_RowChangedName="CommentsOnStatusRowChanged" msprop:Generator_RowClassName="CommentsOnStatusRow" msprop:Generator_RowChangingName="CommentsOnStatusRowChanging" msprop:Generator_RowEvArgName="CommentsOnStatusRowChangeEvent" msprop:Generator_RowEvHandlerName="CommentsOnStatusRowChangeEventHandler" msprop:Generator_TableClassName="CommentsOnStatusDataTable" msprop:Generator_TableVarName="tableCommentsOnStatus" msprop:Generator_RowDeletingName="CommentsOnStatusRowDeleting" msprop:Generator_TablePropName="CommentsOnStatus">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="comment_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="comment_id" msprop:Generator_ColumnPropNameInRow="comment_id" msprop:Generator_ColumnVarNameInTable="columncomment_id" msprop:Generator_ColumnPropNameInTable="comment_idColumn" type="xs:int" />
              <xs:element name="commentDescription" msprop:Generator_UserColumnName="commentDescription" msprop:Generator_ColumnPropNameInRow="commentDescription" msprop:Generator_ColumnVarNameInTable="columncommentDescription" msprop:Generator_ColumnPropNameInTable="commentDescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status_id" msprop:Generator_UserColumnName="status_id" msprop:Generator_ColumnPropNameInRow="status_id" msprop:Generator_ColumnVarNameInTable="columnstatus_id" msprop:Generator_ColumnPropNameInTable="status_idColumn" type="xs:int" />
              <xs:element name="statusName" msprop:Generator_UserColumnName="statusName" msprop:Generator_ColumnPropNameInRow="statusName" msprop:Generator_ColumnVarNameInTable="columnstatusName" msprop:Generator_ColumnPropNameInTable="statusNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkOrders1" msprop:Generator_UserTableName="WorkOrders1" msprop:Generator_RowDeletedName="WorkOrders1RowDeleted" msprop:Generator_RowChangedName="WorkOrders1RowChanged" msprop:Generator_RowClassName="WorkOrders1Row" msprop:Generator_RowChangingName="WorkOrders1RowChanging" msprop:Generator_RowEvArgName="WorkOrders1RowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrders1RowChangeEventHandler" msprop:Generator_TableClassName="WorkOrders1DataTable" msprop:Generator_TableVarName="tableWorkOrders1" msprop:Generator_RowDeletingName="WorkOrders1RowDeleting" msprop:Generator_TablePropName="WorkOrders1">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="workorder_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="workorder_id" msprop:Generator_ColumnPropNameInRow="workorder_id" msprop:Generator_ColumnVarNameInTable="columnworkorder_id" msprop:Generator_ColumnPropNameInTable="workorder_idColumn" type="xs:int" />
              <xs:element name="workorder_reference_no" msprop:Generator_UserColumnName="workorder_reference_no" msprop:Generator_ColumnPropNameInRow="workorder_reference_no" msprop:Generator_ColumnVarNameInTable="columnworkorder_reference_no" msprop:Generator_ColumnPropNameInTable="workorder_reference_noColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machine_id" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="action" msprop:Generator_UserColumnName="action" msprop:Generator_ColumnPropNameInRow="action" msprop:Generator_ColumnVarNameInTable="columnaction" msprop:Generator_ColumnPropNameInTable="actionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_submitted" msprop:Generator_UserColumnName="date_submitted" msprop:Generator_ColumnPropNameInRow="date_submitted" msprop:Generator_ColumnVarNameInTable="columndate_submitted" msprop:Generator_ColumnPropNameInTable="date_submittedColumn" type="xs:string" minOccurs="0" />
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkOrders2" msprop:Generator_UserTableName="WorkOrders2" msprop:Generator_RowDeletedName="WorkOrders2RowDeleted" msprop:Generator_RowChangedName="WorkOrders2RowChanged" msprop:Generator_RowClassName="WorkOrders2Row" msprop:Generator_RowChangingName="WorkOrders2RowChanging" msprop:Generator_RowEvArgName="WorkOrders2RowChangeEvent" msprop:Generator_RowEvHandlerName="WorkOrders2RowChangeEventHandler" msprop:Generator_TableClassName="WorkOrders2DataTable" msprop:Generator_TableVarName="tableWorkOrders2" msprop:Generator_RowDeletingName="WorkOrders2RowDeleting" msprop:Generator_TablePropName="WorkOrders2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="workorder_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="workorder_id" msprop:Generator_ColumnPropNameInRow="workorder_id" msprop:Generator_ColumnVarNameInTable="columnworkorder_id" msprop:Generator_ColumnPropNameInTable="workorder_idColumn" type="xs:int" />
              <xs:element name="workorder_reference_no" msprop:Generator_UserColumnName="workorder_reference_no" msprop:Generator_ColumnPropNameInRow="workorder_reference_no" msprop:Generator_ColumnVarNameInTable="columnworkorder_reference_no" msprop:Generator_ColumnPropNameInTable="workorder_reference_noColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machine_id" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="action" msprop:Generator_UserColumnName="action" msprop:Generator_ColumnPropNameInRow="action" msprop:Generator_ColumnVarNameInTable="columnaction" msprop:Generator_ColumnPropNameInTable="actionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_submitted" msprop:Generator_UserColumnName="date_submitted" msprop:Generator_ColumnPropNameInRow="date_submitted" msprop:Generator_ColumnVarNameInTable="columndate_submitted" msprop:Generator_ColumnPropNameInTable="date_submittedColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TestInterVal" msprop:Generator_UserTableName="TestInterVal" msprop:Generator_RowDeletedName="TestInterValRowDeleted" msprop:Generator_RowChangedName="TestInterValRowChanged" msprop:Generator_RowClassName="TestInterValRow" msprop:Generator_RowChangingName="TestInterValRowChanging" msprop:Generator_RowEvArgName="TestInterValRowChangeEvent" msprop:Generator_RowEvHandlerName="TestInterValRowChangeEventHandler" msprop:Generator_TableClassName="TestInterValDataTable" msprop:Generator_TableVarName="tableTestInterVal" msprop:Generator_RowDeletingName="TestInterValRowDeleting" msprop:Generator_TablePropName="TestInterVal">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Interval_Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Interval_Id" msprop:Generator_ColumnPropNameInRow="Interval_Id" msprop:Generator_ColumnVarNameInTable="columnInterval_Id" msprop:Generator_ColumnPropNameInTable="Interval_IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CompanyID" msprop:Generator_UserColumnName="CompanyID" msprop:Generator_ColumnPropNameInRow="CompanyID" msprop:Generator_ColumnVarNameInTable="columnCompanyID" msprop:Generator_ColumnPropNameInTable="CompanyIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Site_ID" msprop:Generator_UserColumnName="Site_ID" msprop:Generator_ColumnPropNameInRow="Site_ID" msprop:Generator_ColumnVarNameInTable="columnSite_ID" msprop:Generator_ColumnPropNameInTable="Site_IDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ComponentForClient" msprop:Generator_UserTableName="ComponentForClient" msprop:Generator_RowDeletedName="ComponentForClientRowDeleted" msprop:Generator_RowChangedName="ComponentForClientRowChanged" msprop:Generator_RowClassName="ComponentForClientRow" msprop:Generator_RowChangingName="ComponentForClientRowChanging" msprop:Generator_RowEvArgName="ComponentForClientRowChangeEvent" msprop:Generator_RowEvHandlerName="ComponentForClientRowChangeEventHandler" msprop:Generator_TableClassName="ComponentForClientDataTable" msprop:Generator_TableVarName="tableComponentForClient" msprop:Generator_RowDeletingName="ComponentForClientRowDeleting" msprop:Generator_TablePropName="ComponentForClient">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="client_id" msprop:Generator_UserColumnName="client_id" msprop:Generator_ColumnPropNameInRow="client_id" msprop:Generator_ColumnVarNameInTable="columnclient_id" msprop:Generator_ColumnPropNameInTable="client_idColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MachinesOnSites" msprop:Generator_UserTableName="MachinesOnSites" msprop:Generator_RowDeletedName="MachinesOnSitesRowDeleted" msprop:Generator_RowChangedName="MachinesOnSitesRowChanged" msprop:Generator_RowClassName="MachinesOnSitesRow" msprop:Generator_RowChangingName="MachinesOnSitesRowChanging" msprop:Generator_RowEvArgName="MachinesOnSitesRowChangeEvent" msprop:Generator_RowEvHandlerName="MachinesOnSitesRowChangeEventHandler" msprop:Generator_TableClassName="MachinesOnSitesDataTable" msprop:Generator_TableVarName="tableMachinesOnSites" msprop:Generator_RowDeletingName="MachinesOnSitesRowDeleting" msprop:Generator_TablePropName="MachinesOnSites">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="machine_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="machine_id" msprop:Generator_ColumnPropNameInRow="machine_id" msprop:Generator_ColumnVarNameInTable="columnmachine_id" msprop:Generator_ColumnPropNameInTable="machine_idColumn" type="xs:int" />
              <xs:element name="site_id" msprop:Generator_UserColumnName="site_id" msprop:Generator_ColumnPropNameInRow="site_id" msprop:Generator_ColumnVarNameInTable="columnsite_id" msprop:Generator_ColumnPropNameInTable="site_idColumn" type="xs:int" />
              <xs:element name="machineName" msprop:Generator_UserColumnName="machineName" msprop:Generator_ColumnPropNameInRow="machineName" msprop:Generator_ColumnVarNameInTable="columnmachineName" msprop:Generator_ColumnPropNameInTable="machineNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="photo" msprop:Generator_UserColumnName="photo" msprop:Generator_ColumnPropNameInRow="photo" msprop:Generator_ColumnVarNameInTable="columnphoto" msprop:Generator_ColumnPropNameInTable="photoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="machineType_id" msprop:Generator_UserColumnName="machineType_id" msprop:Generator_ColumnPropNameInRow="machineType_id" msprop:Generator_ColumnVarNameInTable="columnmachineType_id" msprop:Generator_ColumnPropNameInTable="machineType_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Expr1" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Expr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" type="xs:int" />
              <xs:element name="siteName" msprop:Generator_UserColumnName="siteName" msprop:Generator_ColumnPropNameInRow="siteName" msprop:Generator_ColumnVarNameInTable="columnsiteName" msprop:Generator_ColumnPropNameInTable="siteNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="client_id" msprop:Generator_UserColumnName="client_id" msprop:Generator_ColumnPropNameInRow="client_id" msprop:Generator_ColumnVarNameInTable="columnclient_id" msprop:Generator_ColumnPropNameInTable="client_idColumn" type="xs:int" />
              <xs:element name="Expr2" msprop:Generator_UserColumnName="Expr2" msprop:Generator_ColumnPropNameInRow="Expr2" msprop:Generator_ColumnVarNameInTable="columnExpr2" msprop:Generator_ColumnPropNameInTable="Expr2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="11" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="OilReports" msprop:Generator_UserTableName="OilReports" msprop:Generator_RowDeletedName="OilReportsRowDeleted" msprop:Generator_RowChangedName="OilReportsRowChanged" msprop:Generator_RowClassName="OilReportsRow" msprop:Generator_RowChangingName="OilReportsRowChanging" msprop:Generator_RowEvArgName="OilReportsRowChangeEvent" msprop:Generator_RowEvHandlerName="OilReportsRowChangeEventHandler" msprop:Generator_TableClassName="OilReportsDataTable" msprop:Generator_TableVarName="tableOilReports" msprop:Generator_RowDeletingName="OilReportsRowDeleting" msprop:Generator_TablePropName="OilReports">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="sample_id" msprop:Generator_UserColumnName="sample_id" msprop:Generator_ColumnVarNameInTable="columnsample_id" msprop:Generator_ColumnPropNameInRow="sample_id" msprop:Generator_ColumnPropNameInTable="sample_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Component_id" msprop:Generator_UserColumnName="Component_id" msprop:Generator_ColumnVarNameInTable="columnComponent_id" msprop:Generator_ColumnPropNameInRow="Component_id" msprop:Generator_ColumnPropNameInTable="Component_idColumn" type="xs:int" />
              <xs:element name="receive_date" msprop:Generator_UserColumnName="receive_date" msprop:Generator_ColumnVarNameInTable="columnreceive_date" msprop:Generator_ColumnPropNameInRow="receive_date" msprop:Generator_ColumnPropNameInTable="receive_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tested_date" msprop:Generator_UserColumnName="tested_date" msprop:Generator_ColumnVarNameInTable="columntested_date" msprop:Generator_ColumnPropNameInRow="tested_date" msprop:Generator_ColumnPropNameInTable="tested_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="reportlink" msprop:Generator_UserColumnName="reportlink" msprop:Generator_ColumnVarNameInTable="columnreportlink" msprop:Generator_ColumnPropNameInRow="reportlink" msprop:Generator_ColumnPropNameInTable="reportlinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DAOilReports" msprop:Generator_UserTableName="DAOilReports" msprop:Generator_RowDeletedName="DAOilReportsRowDeleted" msprop:Generator_TableClassName="DAOilReportsDataTable" msprop:Generator_RowChangedName="DAOilReportsRowChanged" msprop:Generator_RowClassName="DAOilReportsRow" msprop:Generator_RowChangingName="DAOilReportsRowChanging" msprop:Generator_RowEvArgName="DAOilReportsRowChangeEvent" msprop:Generator_RowEvHandlerName="DAOilReportsRowChangeEventHandler" msprop:Generator_TablePropName="DAOilReports" msprop:Generator_TableVarName="tableDAOilReports" msprop:Generator_RowDeletingName="DAOilReportsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="sample_id" msprop:Generator_UserColumnName="sample_id" msprop:Generator_ColumnPropNameInRow="sample_id" msprop:Generator_ColumnVarNameInTable="columnsample_id" msprop:Generator_ColumnPropNameInTable="sample_idColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Component_id" msprop:Generator_UserColumnName="Component_id" msprop:Generator_ColumnPropNameInRow="Component_id" msprop:Generator_ColumnVarNameInTable="columnComponent_id" msprop:Generator_ColumnPropNameInTable="Component_idColumn" type="xs:int" />
              <xs:element name="receive_date" msprop:Generator_UserColumnName="receive_date" msprop:Generator_ColumnPropNameInRow="receive_date" msprop:Generator_ColumnVarNameInTable="columnreceive_date" msprop:Generator_ColumnPropNameInTable="receive_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tested_date" msprop:Generator_UserColumnName="tested_date" msprop:Generator_ColumnPropNameInRow="tested_date" msprop:Generator_ColumnVarNameInTable="columntested_date" msprop:Generator_ColumnPropNameInTable="tested_dateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="reportlink" msprop:Generator_UserColumnName="reportlink" msprop:Generator_ColumnPropNameInRow="reportlink" msprop:Generator_ColumnVarNameInTable="columnreportlink" msprop:Generator_ColumnPropNameInTable="reportlinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="status" msprop:Generator_UserColumnName="status" msprop:Generator_ColumnPropNameInRow="status" msprop:Generator_ColumnVarNameInTable="columnstatus" msprop:Generator_ColumnPropNameInTable="statusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:user_id" />
    </xs:unique>
    <xs:unique name="Components_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Components" />
      <xs:field xpath="mstns:component_id" />
    </xs:unique>
    <xs:unique name="WorkOrders_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkOrders" />
      <xs:field xpath="mstns:workorder_id" />
    </xs:unique>
    <xs:unique name="Status_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Status" />
      <xs:field xpath="mstns:status_id" />
    </xs:unique>
    <xs:unique name="ComponentStatus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ComponentStatus" />
      <xs:field xpath="mstns:component_id" />
      <xs:field xpath="mstns:dateRecorded" />
    </xs:unique>
    <xs:unique name="StandardComments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:StandardComments" />
      <xs:field xpath="mstns:comment_id" />
    </xs:unique>
    <xs:unique name="SitesOnClients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SitesOnClients" />
      <xs:field xpath="mstns:site_id" />
    </xs:unique>
    <xs:unique name="ComponentsOnMachines_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ComponentsOnMachines" />
      <xs:field xpath="mstns:component_id" />
    </xs:unique>
    <xs:unique name="ComponentStatusOnComponents_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ComponentStatusOnComponents" />
      <xs:field xpath="mstns:component_id" />
      <xs:field xpath="mstns:dateRecorded" />
    </xs:unique>
    <xs:unique name="WorkOrdersOnMachines_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkOrdersOnMachines" />
      <xs:field xpath="mstns:workorder_id" />
    </xs:unique>
    <xs:unique name="Sites_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Sites" />
      <xs:field xpath="mstns:site_id" />
    </xs:unique>
    <xs:unique name="Machines_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Machines" />
      <xs:field xpath="mstns:machine_id" />
    </xs:unique>
    <xs:unique name="Clients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Clients" />
      <xs:field xpath="mstns:client_id" />
    </xs:unique>
    <xs:unique name="CommentsOnStatus_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CommentsOnStatus" />
      <xs:field xpath="mstns:comment_id" />
    </xs:unique>
    <xs:unique name="WorkOrders1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkOrders1" />
      <xs:field xpath="mstns:workorder_id" />
    </xs:unique>
    <xs:unique name="WorkOrders2_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkOrders2" />
      <xs:field xpath="mstns:workorder_id" />
    </xs:unique>
    <xs:unique name="TestInterVal_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TestInterVal" />
      <xs:field xpath="mstns:Interval_Id" />
    </xs:unique>
    <xs:unique name="ComponentForClient_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ComponentForClient" />
      <xs:field xpath="mstns:client_id" />
    </xs:unique>
    <xs:unique name="MachinesOnSites_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MachinesOnSites" />
      <xs:field xpath="mstns:machine_id" />
      <xs:field xpath="mstns:Expr1" />
    </xs:unique>
    <xs:unique name="OilReports_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OilReports" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="DAOilReports_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DAOilReports" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Components_Machines" msdata:parent="Machines" msdata:child="Components" msdata:parentkey="machine_id" msdata:childkey="machine_id" msprop:Generator_UserRelationName="FK_Components_Machines" msprop:Generator_RelationVarName="relationFK_Components_Machines" msprop:Generator_UserChildTable="Components" msprop:Generator_UserParentTable="Machines" msprop:Generator_ParentPropName="MachinesRow" msprop:Generator_ChildPropName="GetComponentsRows" />
      <msdata:Relationship name="FK_WorkOrders_Machines" msdata:parent="Machines" msdata:child="WorkOrders" msdata:parentkey="machine_id" msdata:childkey="machine_id" msprop:Generator_UserRelationName="FK_WorkOrders_Machines" msprop:Generator_RelationVarName="relationFK_WorkOrders_Machines" msprop:Generator_UserChildTable="WorkOrders" msprop:Generator_UserParentTable="Machines" msprop:Generator_ParentPropName="MachinesRow" msprop:Generator_ChildPropName="GetWorkOrdersRows" />
      <msdata:Relationship name="FK_Machines_Sites" msdata:parent="Sites" msdata:child="Machines" msdata:parentkey="site_id" msdata:childkey="site_id" msprop:Generator_UserRelationName="FK_Machines_Sites" msprop:Generator_RelationVarName="relationFK_Machines_Sites" msprop:Generator_UserChildTable="Machines" msprop:Generator_UserParentTable="Sites" msprop:Generator_ParentPropName="SitesRow" msprop:Generator_ChildPropName="GetMachinesRows" />
      <msdata:Relationship name="FK_ComponentStatus_Components" msdata:parent="Components" msdata:child="ComponentStatus" msdata:parentkey="component_id" msdata:childkey="component_id" msprop:Generator_UserRelationName="FK_ComponentStatus_Components" msprop:Generator_RelationVarName="relationFK_ComponentStatus_Components" msprop:Generator_UserChildTable="ComponentStatus" msprop:Generator_UserParentTable="Components" msprop:Generator_ParentPropName="ComponentsRow" msprop:Generator_ChildPropName="GetComponentStatusRows" />
      <msdata:Relationship name="FK_Users_Clients" msdata:parent="Clients" msdata:child="Users" msdata:parentkey="client_id" msdata:childkey="client_id" msprop:Generator_UserRelationName="FK_Users_Clients" msprop:Generator_RelationVarName="relationFK_Users_Clients" msprop:Generator_UserChildTable="Users" msprop:Generator_UserParentTable="Clients" msprop:Generator_ParentPropName="ClientsRow" msprop:Generator_ChildPropName="GetUsersRows" />
      <msdata:Relationship name="FK_Sites_Clients" msdata:parent="Clients" msdata:child="Sites" msdata:parentkey="client_id" msdata:childkey="client_id" msprop:Generator_UserRelationName="FK_Sites_Clients" msprop:Generator_RelationVarName="relationFK_Sites_Clients" msprop:Generator_UserChildTable="Sites" msprop:Generator_UserParentTable="Clients" msprop:Generator_ParentPropName="ClientsRow" msprop:Generator_ChildPropName="GetSitesRows" />
      <msdata:Relationship name="FK_WorkOrders_Machines1" msdata:parent="Machines" msdata:child="WorkOrders1" msdata:parentkey="machine_id" msdata:childkey="machine_id" msprop:Generator_UserRelationName="FK_WorkOrders_Machines1" msprop:Generator_RelationVarName="relationFK_WorkOrders_Machines1" msprop:Generator_UserChildTable="WorkOrders1" msprop:Generator_UserParentTable="Machines" msprop:Generator_ParentPropName="MachinesRow" msprop:Generator_ChildPropName="GetWorkOrders1Rows" />
      <msdata:Relationship name="FK_WorkOrders_Machines2" msdata:parent="Machines" msdata:child="WorkOrders2" msdata:parentkey="machine_id" msdata:childkey="machine_id" msprop:Generator_UserRelationName="FK_WorkOrders_Machines2" msprop:Generator_RelationVarName="relationFK_WorkOrders_Machines2" msprop:Generator_UserChildTable="WorkOrders2" msprop:Generator_UserParentTable="Machines" msprop:Generator_ParentPropName="MachinesRow" msprop:Generator_ChildPropName="GetWorkOrders2Rows" />
      <msdata:Relationship name="FK_Components_TestInterVal" msdata:parent="TestInterVal" msdata:child="Components" msdata:parentkey="Interval_Id" msdata:childkey="Interval_Id" msprop:Generator_UserRelationName="FK_Components_TestInterVal" msprop:Generator_RelationVarName="relationFK_Components_TestInterVal" msprop:Generator_UserChildTable="Components" msprop:Generator_UserParentTable="TestInterVal" msprop:Generator_ParentPropName="TestInterValRow" msprop:Generator_ChildPropName="GetComponentsRows" />
      <msdata:Relationship name="FK_TestInterVal_Clients" msdata:parent="Clients" msdata:child="TestInterVal" msdata:parentkey="client_id" msdata:childkey="CompanyID" msprop:Generator_UserRelationName="FK_TestInterVal_Clients" msprop:Generator_RelationVarName="relationFK_TestInterVal_Clients" msprop:Generator_UserChildTable="TestInterVal" msprop:Generator_UserParentTable="Clients" msprop:Generator_ParentPropName="ClientsRow" msprop:Generator_ChildPropName="GetTestInterValRows" />
      <msdata:Relationship name="FK_TestInterVal_Sites" msdata:parent="Sites" msdata:child="TestInterVal" msdata:parentkey="site_id" msdata:childkey="Site_ID" msprop:Generator_UserRelationName="FK_TestInterVal_Sites" msprop:Generator_RelationVarName="relationFK_TestInterVal_Sites" msprop:Generator_UserChildTable="TestInterVal" msprop:Generator_UserParentTable="Sites" msprop:Generator_ParentPropName="SitesRow" msprop:Generator_ChildPropName="GetTestInterValRows" />
      <msdata:Relationship name="FK_Users_Clients1" msdata:parent="ComponentForClient" msdata:child="Users" msdata:parentkey="client_id" msdata:childkey="client_id" msprop:Generator_UserRelationName="FK_Users_Clients1" msprop:Generator_RelationVarName="relationFK_Users_Clients1" msprop:Generator_UserChildTable="Users" msprop:Generator_UserParentTable="ComponentForClient" msprop:Generator_ParentPropName="ComponentForClientRow" msprop:Generator_ChildPropName="GetUsersRows" />
      <msdata:Relationship name="FK_Sites_Clients1" msdata:parent="ComponentForClient" msdata:child="Sites" msdata:parentkey="client_id" msdata:childkey="client_id" msprop:Generator_UserRelationName="FK_Sites_Clients1" msprop:Generator_RelationVarName="relationFK_Sites_Clients1" msprop:Generator_UserChildTable="Sites" msprop:Generator_UserParentTable="ComponentForClient" msprop:Generator_ParentPropName="MachinesOnSitesRow" msprop:Generator_ChildPropName="GetSitesRows" />
      <msdata:Relationship name="FK_TestInterVal_Clients1" msdata:parent="ComponentForClient" msdata:child="TestInterVal" msdata:parentkey="client_id" msdata:childkey="CompanyID" msprop:Generator_UserRelationName="FK_TestInterVal_Clients1" msprop:Generator_RelationVarName="relationFK_TestInterVal_Clients1" msprop:Generator_UserChildTable="TestInterVal" msprop:Generator_UserParentTable="ComponentForClient" msprop:Generator_ParentPropName="MachinesOnSitesRow" msprop:Generator_ChildPropName="GetTestInterValRows" />
      <msdata:Relationship name="FK_WorkOrders_Machines3" msdata:parent="MachinesOnSites" msdata:child="WorkOrders" msdata:parentkey="machine_id" msdata:childkey="machine_id" msprop:Generator_UserRelationName="FK_WorkOrders_Machines3" msprop:Generator_RelationVarName="relationFK_WorkOrders_Machines3" msprop:Generator_UserChildTable="WorkOrders" msprop:Generator_UserParentTable="MachinesOnSites" msprop:Generator_ParentPropName="MachinesOnSitesRow" msprop:Generator_ChildPropName="GetWorkOrdersRows" />
      <msdata:Relationship name="FK_WorkOrders_Machines4" msdata:parent="MachinesOnSites" msdata:child="WorkOrders1" msdata:parentkey="machine_id" msdata:childkey="machine_id" msprop:Generator_UserRelationName="FK_WorkOrders_Machines4" msprop:Generator_RelationVarName="relationFK_WorkOrders_Machines4" msprop:Generator_UserChildTable="WorkOrders1" msprop:Generator_UserParentTable="MachinesOnSites" msprop:Generator_ParentPropName="MachinesOnSitesRow" msprop:Generator_ChildPropName="GetWorkOrders1Rows" />
      <msdata:Relationship name="FK_WorkOrders_Machines5" msdata:parent="MachinesOnSites" msdata:child="WorkOrders2" msdata:parentkey="machine_id" msdata:childkey="machine_id" msprop:Generator_UserRelationName="FK_WorkOrders_Machines5" msprop:Generator_RelationVarName="relationFK_WorkOrders_Machines5" msprop:Generator_UserChildTable="WorkOrders2" msprop:Generator_UserParentTable="MachinesOnSites" msprop:Generator_ParentPropName="MachinesOnSitesRow" msprop:Generator_ChildPropName="GetWorkOrders2Rows" />
      <msdata:Relationship name="FK_Machines_Sites1" msdata:parent="Sites" msdata:child="MachinesOnSites" msdata:parentkey="site_id" msdata:childkey="site_id" msprop:Generator_UserRelationName="FK_Machines_Sites1" msprop:Generator_RelationVarName="relationFK_Machines_Sites1" msprop:Generator_UserChildTable="MachinesOnSites" msprop:Generator_UserParentTable="Sites" msprop:Generator_ParentPropName="SitesRow" msprop:Generator_ChildPropName="GetMachinesOnSitesRows" />
      <msdata:Relationship name="FK_OilReports_Components" msdata:parent="Components" msdata:child="OilReports" msdata:parentkey="component_id" msdata:childkey="Component_id" msprop:Generator_UserRelationName="FK_OilReports_Components" msprop:Generator_RelationVarName="relationFK_OilReports_Components" msprop:Generator_UserChildTable="OilReports" msprop:Generator_UserParentTable="Components" msprop:Generator_ParentPropName="ComponentsRow" msprop:Generator_ChildPropName="GetOilReportsRows" />
      <msdata:Relationship name="FK_OilReports_Components1" msdata:parent="Components" msdata:child="DAOilReports" msdata:parentkey="component_id" msdata:childkey="Component_id" msprop:Generator_UserRelationName="FK_OilReports_Components1" msprop:Generator_RelationVarName="relationFK_OilReports_Components1" msprop:Generator_UserChildTable="DAOilReports" msprop:Generator_UserParentTable="Components" msprop:Generator_ParentPropName="ComponentsRow" msprop:Generator_ChildPropName="GetDAOilReportsRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>